<%@ page language="java" contentType="text/html; charset=utf-8"
    pageEncoding="utf-8"%>
    <%@ page import="java.sql.*" %>
<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8">
<title>Insert title here</title>
</head>
<body bgcolor="cccfff">
    <jsp:useBean id="dbconn" class="bean.DBConnectionManager"></jsp:useBean>
<%
    //DBConnectionManager dbconn=new DBConnectionManager();
    Connection con=dbconn.getConnection();
 Statement stmt=con.createStatement(); 
 %>
 <center>
    <br><br><br>
    <h3>&nbsp;&nbsp;修改教师信息 </h3>
  	<form action="updateTeacherCheck.jsp" method="post">

  	  
  	  <table border="0" width="300">
  	    <tr>
  	      <td>修改编号</td>
  	      <td>
  	        <select name="id">
       		 <%String TNo=null;
       		 	String Tname=null;
       		 	String Sex=null;
       		 	String Title=null;
          		String sql="select * from t_teacher";
          		ResultSet rs=stmt.executeQuery(sql);
          		while(rs.next()){
        	    TNo=rs.getString("teano");
            	Tname=rs.getString("teaname");
        	    Sex=rs.getString("teasex");
        	    Title=rs.getString("title");
        	    
             %>
             <option value="<%=TNo%>"><%=TNo %></option>
            <%
             }
            %> 
           </select>
  	       </td>    	          
  	    </tr>
  	    <tr>
  	      <td>姓名</td>
  	      <td><input type="text" name="teaname" ></td>      
  	    </tr>
  	    <tr>
  	      <td>性别</td>
  	      <td><input type="text" name="teasex" ></td>      
  	    </tr>
  	    <tr>
  	      <td>职位</td>
  	      <td><input type="text" name="title" ></td>      
  	    </tr>
  	    
  	    <tr align="center">
	     <td colspan="2">
	      <input name="sure" type="submit" value="提  交">
	      &nbsp;&nbsp;&nbsp;&nbsp;
	      <input name="clear" type="reset" value="取  消">
	     </td>
	  </tr>  
  	  </table>  	
  	</from>  
  </center> 
</body>
</html>